CREATE TABLE [dbo].[TTCOPA_ANUL]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[TI_COMP_PAGO] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NU_COMP_PAGO] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_TIPO_OPER] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FE_ANUL] [datetime] NOT NULL,
[ST_CONT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__TTCOPA_AN__ST_CO__77809FC6] DEFAULT ('N'),
[NU_PROC] [int] NOT NULL CONSTRAINT [DF__TTCOPA_AN__NU_PR__7874C3FF] DEFAULT ((0)),
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTCOPA_AN__CO_US__7968E838] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TTCOPA_AN__FE_US__7A5D0C71] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTCOPA_AN__CO_US__7B5130AA] DEFAULT (suser_sname()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TTCOPA_AN__FE_US__7C4554E3] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTCOPA_ANUL] ADD CONSTRAINT [PK__TTCOPA_A__17DCF2A70F63164F] PRIMARY KEY CLUSTERED  ([CO_EMPR], [TI_COMP_PAGO], [NU_COMP_PAGO]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTCOPA_ANUL] ADD CONSTRAINT [FK__TTCOPA_AN__CO_EM__4DB54E83] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
